﻿CREATE TABLE [dbo].[Audit] (
    [ID]                BIGINT        IDENTITY (1, 1) NOT NULL,
    [TableName]         VARCHAR (128) NOT NULL,
    [PrimaryKeyColumns] VARCHAR (128) NOT NULL,
    [PrimaryKeyValues]  VARCHAR (128) NOT NULL,
    [Timestamp]         DATETIME      NOT NULL,
    [UserID]            VARCHAR (128) NOT NULL,
    [ColumnName]        VARCHAR (128) NOT NULL,
    [OldValue]          VARCHAR (200) NULL,
    [NewValue]          VARCHAR (200) NULL
);

